package com.zlx.mall.base.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import java.io.Serializable;
import java.math.BigDecimal;
import java.time.Instant;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.experimental.Accessors;

/**
 * <p>
 * 商品表
 * </p>
 *
 * @author xiatian
 */
@Data
@NoArgsConstructor
@AllArgsConstructor
@Accessors(chain = true)
@TableName("`sc_goods`")
public class ScGoods implements Serializable {

    private static final long serialVersionUID = 1L;

    /** PK,AI */
    @TableId(value = "`id`", type = IdType.AUTO)
    private Long id;
    /** 商品名称 */
    @TableField("`name`")
    private String name;
    /** 一级分类ID */
    @TableField("`category_id`")
    private Long categoryId;
    /** 二级分类ID */
    @TableField("`sub_category_id`")
    private Long subCategoryId;
    /** 商品状态:1上架，0下架 */
    @TableField("`status`")
    private Integer status;
    /** 1-基础商品，2-加购商品 */
    @TableField("`type`")
    private Integer type;
    /** 型号 */
    @TableField("`model`")
    private String model;
    /** 材质 */
    @TableField("`material`")
    private String material;
    /** 规格 */
    @TableField("`property`")
    private String property;
    /** 标签 */
    @TableField("`label`")
    private String label;
    /** 商品主图 */
    @TableField("`main_img`")
    private String mainImg;
    /** 详情富文本 */
    @TableField("`details_img`")
    private String detailsImg;
    /** 备注描述 */
    @TableField("`remark`")
    private String remark;
    /** 商品售价 */
    @TableField("`sale_price`")
    private BigDecimal salePrice;
    /** 删除状态 {0-exist !0-deleted} */
    @TableField("`is_delete`")
    private Long isDelete;
    /** 创建时间 */
    @TableField("`create_timestamp`")
    private Instant createTimestamp;
    /** 修改时间 */
    @TableField("`modify_timestamp`")
    private Instant modifyTimestamp;
    /** 创建人id */
    @TableField("`create_operator_id`")
    private Long createOperatorId;
    /** 修改人id */
    @TableField("`modify_operator_id`")
    private Long modifyOperatorId;

    /** PK,AI */
    public static final String ID = "id";
    /** 商品名称 */
    public static final String NAME = "name";
    /** 一级分类ID */
    public static final String CATEGORY_ID = "category_id";
    /** 二级分类ID */
    public static final String SUB_CATEGORY_ID = "sub_category_id";
    /** 商品状态:1上架，0下架 */
    public static final String STATUS = "status";
    /** 1-基础商品，2-加购商品 */
    public static final String TYPE = "type";
    /** 型号 */
    public static final String MODEL = "model";
    /** 材质 */
    public static final String MATERIAL = "material";
    /** 规格 */
    public static final String PROPERTY = "property";
    /** 标签 */
    public static final String LABEL = "label";
    /** 商品主图 */
    public static final String MAIN_IMG = "main_img";
    /** 详情富文本 */
    public static final String DETAILS_IMG = "details_img";
    /** 备注描述 */
    public static final String REMARK = "remark";
    /** 商品售价 */
    public static final String SALE_PRICE = "sale_price";
    /** 删除状态 {0-exist !0-deleted} */
    public static final String IS_DELETE = "is_delete";
    /** 创建时间 */
    public static final String CREATE_TIMESTAMP = "create_timestamp";
    /** 修改时间 */
    public static final String MODIFY_TIMESTAMP = "modify_timestamp";
    /** 创建人id */
    public static final String CREATE_OPERATOR_ID = "create_operator_id";
    /** 修改人id */
    public static final String MODIFY_OPERATOR_ID = "modify_operator_id";
}
